Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 284807 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 19335 |
| Duplicate rows (%) | 6.8% |
| Total size in memory | 23.9 MiB |
| Average record size in memory | 88.0 B |
Variable types
| Numeric | 11 |
|---|
| Dataset has 19335 (6.8%) duplicate rows | Duplicates |
u is highly correlated with g and 6 other fields | High correlation |
g is highly correlated with u and 8 other fields | High correlation |
r is highly correlated with u and 8 other fields | High correlation |
i is highly correlated with u and 7 other fields | High correlation |
z is highly correlated with u and 7 other fields | High correlation |
uErr is highly correlated with u and 4 other fields | High correlation |
gErr is highly correlated with u and 8 other fields | High correlation |
rErr is highly correlated with u and 8 other fields | High correlation |
iErr is highly correlated with g and 6 other fields | High correlation |
zErr is highly correlated with g and 6 other fields | High correlation |
u is highly correlated with g and 3 other fields | High correlation |
g is highly correlated with u and 3 other fields | High correlation |
r is highly correlated with u and 3 other fields | High correlation |
i is highly correlated with u and 3 other fields | High correlation |
z is highly correlated with u and 3 other fields | High correlation |
uErr is highly correlated with gErr and 1 other fields | High correlation |
gErr is highly correlated with uErr and 1 other fields | High correlation |
rErr is highly correlated with uErr and 1 other fields | High correlation |
u is highly correlated with g and 2 other fields | High correlation |
g is highly correlated with u and 5 other fields | High correlation |
r is highly correlated with g and 6 other fields | High correlation |
i is highly correlated with g and 6 other fields | High correlation |
z is highly correlated with g and 6 other fields | High correlation |
uErr is highly correlated with u and 1 other fields | High correlation |
gErr is highly correlated with u and 7 other fields | High correlation |
rErr is highly correlated with g and 6 other fields | High correlation |
iErr is highly correlated with r and 5 other fields | High correlation |
zErr is highly correlated with r and 4 other fields | High correlation |
u is highly correlated with g and 6 other fields | High correlation |
g is highly correlated with u and 6 other fields | High correlation |
r is highly correlated with u and 6 other fields | High correlation |
i is highly correlated with u and 3 other fields | High correlation |
z is highly correlated with u and 3 other fields | High correlation |
uErr is highly correlated with u and 6 other fields | High correlation |
gErr is highly correlated with u and 6 other fields | High correlation |
rErr is highly correlated with u and 6 other fields | High correlation |
iErr is highly correlated with uErr and 3 other fields | High correlation |
zErr is highly correlated with uErr and 3 other fields | High correlation |
uErr is highly skewed (γ1 = 456.7235232) | Skewed |
gErr is highly skewed (γ1 = 422.3944341) | Skewed |
rErr is highly skewed (γ1 = 118.8801239) | Skewed |
iErr is highly skewed (γ1 = 142.2519051) | Skewed |
zErr is highly skewed (γ1 = 41.65436631) | Skewed |
Reproduction
| Analysis started | 2022-02-27 19:48:40.179453 |
|---|---|
| Analysis finished | 2022-02-27 19:49:08.295438 |
| Duration | 28.12 seconds |
| Software version | pandas-profiling v3.1.1 |
| Download configuration | config.json |
ID
Real number (ℝ≥0)
| Distinct | 265471 |
|---|---|
| Distinct (%) | 93.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.237664166 × 1018 |
| Minimum | 1.23764588 × 1018 |
|---|---|
| Maximum | 1.237680531 × 1018 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 1.23764588 × 1018 |
|---|---|
| 5-th percentile | 1.23765125 × 1018 |
| Q1 | 1.237657191 × 1018 |
| median | 1.237663278 × 1018 |
| Q3 | 1.237668625 × 1018 |
| 95-th percentile | 1.237679435 × 1018 |
| Maximum | 1.237680531 × 1018 |
| Range | 3.465179365 × 1013 |
| Interquartile range (IQR) | 1.143318292 × 1013 |
Descriptive statistics
| Standard deviation | 9.234079428 × 1012 |
|---|---|
| Coefficient of variation (CV) | 7.460892609 × 10-6 |
| Kurtosis | -0.8864431604 |
| Mean | 1.237664166 × 1018 |
| Median Absolute Deviation (MAD) | 6.085945065 × 1012 |
| Skewness | 0.3463585308 |
| Sum | -3.414404155 × 1018 |
| Variance | 8.526822288 × 1025 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.237663783 × 1018 | 3 | < 0.1% |
| 1.237651754 × 1018 | 2 | < 0.1% |
| 1.237666089 × 1018 | 2 | < 0.1% |
| 1.237665572 × 1018 | 2 | < 0.1% |
| 1.237665583 × 1018 | 2 | < 0.1% |
| 1.237665583 × 1018 | 2 | < 0.1% |
| 1.237665584 × 1018 | 2 | < 0.1% |
| 1.237665584 × 1018 | 2 | < 0.1% |
| 1.237665584 × 1018 | 2 | < 0.1% |
| 1.237666089 × 1018 | 2 | < 0.1% |
| Other values (265461) | 284786 |
| Value | Count | Frequency (%) |
| 1.23764588 × 1018 | 1 | |
| 1.23764588 × 1018 | 1 | |
| 1.23764588 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 2 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 | |
| 1.237645943 × 1018 | 1 |
| Value | Count | Frequency (%) |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 |
| Distinct | 256277 |
|---|---|
| Distinct (%) | 90.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.53321096 |
| Minimum | 6.137899 |
|---|---|
| Maximum | 31.474758 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 6.137899 |
|---|---|
| 5-th percentile | 18.845813 |
| Q1 | 21.3885025 |
| median | 22.717176 |
| Q3 | 23.931763 |
| 95-th percentile | 25.6771139 |
| Maximum | 31.474758 |
| Range | 25.336859 |
| Interquartile range (IQR) | 2.5432605 |
Descriptive statistics
| Standard deviation | 2.052177283 |
|---|---|
| Coefficient of variation (CV) | 0.09107345094 |
| Kurtosis | 0.01793379229 |
| Mean | 22.53321096 |
| Median Absolute Deviation (MAD) | 1.261786 |
| Skewness | -0.4307088953 |
| Sum | 6417616.213 |
| Variance | 4.2114316 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21.96266 | 5 | < 0.1% |
| 21.968773 | 5 | < 0.1% |
| 22.195639 | 5 | < 0.1% |
| 21.830866 | 5 | < 0.1% |
| 22.850668 | 5 | < 0.1% |
| 23.249609 | 4 | < 0.1% |
| 24.459768 | 4 | < 0.1% |
| 22.973475 | 4 | < 0.1% |
| 22.375 | 4 | < 0.1% |
| 22.340986 | 4 | < 0.1% |
| Other values (256267) | 284762 |
| Value | Count | Frequency (%) |
| 6.137899 | 1 | |
| 7.684486 | 1 | |
| 7.85844 | 1 | |
| 8.107904 | 1 | |
| 8.174813 | 1 | |
| 8.223669 | 1 | |
| 9.046374 | 1 | |
| 9.445343 | 1 | |
| 9.599357 | 1 | |
| 9.680221 | 1 |
| Value | Count | Frequency (%) |
| 31.474758 | 1 | |
| 30.669785 | 1 | |
| 30.045591 | 1 | |
| 30.029575 | 1 | |
| 29.914965 | 1 | |
| 29.584764 | 1 | |
| 29.497486 | 1 | |
| 29.22876 | 1 | |
| 29.190369 | 1 | |
| 28.978514 | 1 |
| Distinct | 253305 |
|---|---|
| Distinct (%) | 88.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.00671317 |
| Minimum | 7.446142 |
|---|---|
| Maximum | 32.311321 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 7.446142 |
|---|---|
| 5-th percentile | 17.3897861 |
| Q1 | 19.9706715 |
| median | 21.568672 |
| Q3 | 22.33006 |
| 95-th percentile | 23.342819 |
| Maximum | 32.311321 |
| Range | 24.865179 |
| Interquartile range (IQR) | 2.3593885 |
Descriptive statistics
| Standard deviation | 1.90592756 |
|---|---|
| Coefficient of variation (CV) | 0.09072945133 |
| Kurtosis | 0.1467433537 |
| Mean | 21.00671317 |
| Median Absolute Deviation (MAD) | 0.971749 |
| Skewness | -0.8255987356 |
| Sum | 5982858.957 |
| Variance | 3.632559864 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 22.417925 | 5 | < 0.1% |
| 21.64337 | 5 | < 0.1% |
| 21.820137 | 5 | < 0.1% |
| 21.692204 | 5 | < 0.1% |
| 21.834551 | 5 | < 0.1% |
| 21.390749 | 5 | < 0.1% |
| 22.388662 | 5 | < 0.1% |
| 22.205276 | 5 | < 0.1% |
| 22.561132 | 5 | < 0.1% |
| 22.0459 | 5 | < 0.1% |
| Other values (253295) | 284757 |
| Value | Count | Frequency (%) |
| 7.446142 | 1 | |
| 8.241127 | 1 | |
| 8.685551 | 1 | |
| 8.854282 | 1 | |
| 8.879968 | 1 | |
| 9.043655 | 1 | |
| 9.541052 | 1 | |
| 9.955412 | 1 | |
| 10.04998 | 1 | |
| 10.204456 | 1 |
| Value | Count | Frequency (%) |
| 32.311321 | 1 | |
| 32.180359 | 1 | |
| 32.180218 | 1 | |
| 31.12199 | 1 | |
| 31.036724 | 1 | |
| 30.37472 | 1 | |
| 30.274063 | 1 | |
| 30.004261 | 1 | |
| 29.916021 | 1 | |
| 29.698931 | 1 |
| Distinct | 253330 |
|---|---|
| Distinct (%) | 88.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.78243101 |
| Minimum | 8.510301 |
|---|---|
| Maximum | 30.481144 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 8.510301 |
|---|---|
| 5-th percentile | 16.6154187 |
| Q1 | 18.68987 |
| median | 20.255796 |
| Q3 | 21.016758 |
| 95-th percentile | 22.0144542 |
| Maximum | 30.481144 |
| Range | 21.970843 |
| Interquartile range (IQR) | 2.326888 |
Descriptive statistics
| Standard deviation | 1.724220553 |
|---|---|
| Coefficient of variation (CV) | 0.08715918445 |
| Kurtosis | -0.04694511422 |
| Mean | 19.78243101 |
| Median Absolute Deviation (MAD) | 1.004759 |
| Skewness | -0.7508721697 |
| Sum | 5634174.828 |
| Variance | 2.972936515 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20.397943 | 6 | < 0.1% |
| 20.158337 | 6 | < 0.1% |
| 20.431469 | 6 | < 0.1% |
| 20.87731 | 6 | < 0.1% |
| 20.49766 | 6 | < 0.1% |
| 21.436712 | 5 | < 0.1% |
| 20.907282 | 5 | < 0.1% |
| 20.083857 | 5 | < 0.1% |
| 20.986086 | 5 | < 0.1% |
| 21.221909 | 5 | < 0.1% |
| Other values (253320) | 284752 |
| Value | Count | Frequency (%) |
| 8.510301 | 1 | |
| 8.871452 | 1 | |
| 9.381433 | 1 | |
| 9.537403 | 1 | |
| 9.54484 | 1 | |
| 9.806157 | 1 | |
| 9.871026 | 1 | |
| 10.18564 | 1 | |
| 10.685715 | 1 | |
| 10.713271 | 1 |
| Value | Count | Frequency (%) |
| 30.481144 | 1 | |
| 27.92935 | 1 | |
| 27.586512 | 1 | |
| 27.531603 | 1 | |
| 27.443832 | 1 | |
| 27.340242 | 1 | |
| 26.760141 | 1 | |
| 26.303787 | 1 | |
| 26.298737 | 1 | |
| 26.275991 | 1 |
| Distinct | 253727 |
|---|---|
| Distinct (%) | 89.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.21205481 |
| Minimum | 9.260902 |
|---|---|
| Maximum | 32.286316 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 9.260902 |
|---|---|
| 5-th percentile | 16.225149 |
| Q1 | 18.150341 |
| median | 19.490479 |
| Q3 | 20.358361 |
| 95-th percentile | 21.7069342 |
| Maximum | 32.286316 |
| Range | 23.025414 |
| Interquartile range (IQR) | 2.20802 |
Descriptive statistics
| Standard deviation | 1.700399292 |
|---|---|
| Coefficient of variation (CV) | 0.08850689367 |
| Kurtosis | 0.1441953057 |
| Mean | 19.21205481 |
| Median Absolute Deviation (MAD) | 1.042099 |
| Skewness | -0.4322199542 |
| Sum | 5471727.693 |
| Variance | 2.891357752 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 19.504345 | 6 | < 0.1% |
| 19.685961 | 5 | < 0.1% |
| 20.096962 | 5 | < 0.1% |
| 19.962057 | 5 | < 0.1% |
| 19.935677 | 5 | < 0.1% |
| 20.149513 | 5 | < 0.1% |
| 19.958929 | 5 | < 0.1% |
| 20.872757 | 5 | < 0.1% |
| 19.263306 | 5 | < 0.1% |
| 20.285532 | 5 | < 0.1% |
| Other values (253717) | 284756 |
| Value | Count | Frequency (%) |
| 9.260902 | 1 | |
| 9.45409 | 1 | |
| 9.481367 | 1 | |
| 9.785824 | 1 | |
| 10.00429 | 1 | |
| 10.210069 | 1 | |
| 10.499023 | 1 | |
| 10.601875 | 1 | |
| 10.667053 | 1 | |
| 11.098452 | 1 |
| Value | Count | Frequency (%) |
| 32.286316 | 1 | |
| 31.575436 | 1 | |
| 31.350872 | 1 | |
| 31.254124 | 1 | |
| 31.156153 | 1 | |
| 31.13089 | 1 | |
| 31.073492 | 1 | |
| 30.873112 | 1 | |
| 30.720078 | 1 | |
| 30.709589 | 1 |
| Distinct | 253767 |
|---|---|
| Distinct (%) | 89.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.88745681 |
| Minimum | 9.688597 |
|---|---|
| Maximum | 29.146568 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 9.688597 |
|---|---|
| 5-th percentile | 15.9315499 |
| Q1 | 17.8106385 |
| median | 19.084158 |
| Q3 | 19.972534 |
| 95-th percentile | 21.5791392 |
| Maximum | 29.146568 |
| Range | 19.457971 |
| Interquartile range (IQR) | 2.1618955 |
Descriptive statistics
| Standard deviation | 1.724723968 |
|---|---|
| Coefficient of variation (CV) | 0.09131583912 |
| Kurtosis | 0.1293595211 |
| Mean | 18.88745681 |
| Median Absolute Deviation (MAD) | 1.044447 |
| Skewness | -0.2580487792 |
| Sum | 5379279.912 |
| Variance | 2.974672765 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 19.348778 | 6 | < 0.1% |
| 19.196115 | 6 | < 0.1% |
| 19.232006 | 5 | < 0.1% |
| 19.491114 | 5 | < 0.1% |
| 20.177359 | 5 | < 0.1% |
| 19.29693 | 5 | < 0.1% |
| 19.518696 | 5 | < 0.1% |
| 19.5366 | 5 | < 0.1% |
| 19.37998 | 5 | < 0.1% |
| 19.744009 | 5 | < 0.1% |
| Other values (253757) | 284755 |
| Value | Count | Frequency (%) |
| 9.688597 | 1 | |
| 10.111669 | 1 | |
| 10.138 | 1 | |
| 10.246193 | 1 | |
| 10.44339 | 1 | |
| 10.667935 | 1 | |
| 10.677568 | 1 | |
| 10.737098 | 1 | |
| 10.83986 | 1 | |
| 10.881444 | 1 |
| Value | Count | Frequency (%) |
| 29.146568 | 1 | |
| 29.105049 | 1 | |
| 28.954861 | 1 | |
| 28.860327 | 1 | |
| 28.741753 | 1 | |
| 28.71353 | 1 | |
| 28.68885 | 1 | |
| 28.670599 | 1 | |
| 28.620174 | 1 | |
| 28.615345 | 1 |
| Distinct | 232977 |
|---|---|
| Distinct (%) | 81.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5054286479 |
| Minimum | 0.011919 |
|---|---|
| Maximum | 973.115381 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0.011919 |
|---|---|
| 5-th percentile | 0.041825 |
| Q1 | 0.1732585 |
| median | 0.423588 |
| Q3 | 0.7323425 |
| 95-th percentile | 1.2197801 |
| Maximum | 973.115381 |
| Range | 973.103462 |
| Interquartile range (IQR) | 0.559084 |
Descriptive statistics
| Standard deviation | 1.924641703 |
|---|---|
| Coefficient of variation (CV) | 3.80793948 |
| Kurtosis | 229236.5859 |
| Mean | 0.5054286479 |
| Median Absolute Deviation (MAD) | 0.275584 |
| Skewness | 456.7235232 |
| Sum | 143949.6169 |
| Variance | 3.704245683 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.094035 | 9 | < 0.1% |
| 0.741354 | 7 | < 0.1% |
| 0.311294 | 6 | < 0.1% |
| 0.063306 | 6 | < 0.1% |
| 0.33322 | 6 | < 0.1% |
| 0.098549 | 6 | < 0.1% |
| 0.04659 | 6 | < 0.1% |
| 0.044189 | 6 | < 0.1% |
| 0.071216 | 6 | < 0.1% |
| 0.652707 | 6 | < 0.1% |
| Other values (232967) | 284743 |
| Value | Count | Frequency (%) |
| 0.011919 | 1 | |
| 0.012259 | 1 | |
| 0.012604 | 2 | |
| 0.013049 | 1 | |
| 0.013249 | 1 | |
| 0.013527 | 1 | |
| 0.013617 | 1 | |
| 0.013656 | 1 | |
| 0.013725 | 1 | |
| 0.01378 | 1 |
| Value | Count | Frequency (%) |
| 973.115381 | 1 | |
| 163.304649 | 1 | |
| 115.003115 | 1 | |
| 86.184253 | 1 | |
| 70.904198 | 1 | |
| 61.491178 | 1 | |
| 53.891129 | 1 | |
| 40.433575 | 1 | |
| 22.030731 | 1 | |
| 17.775392 | 1 |
| Distinct | 171592 |
|---|---|
| Distinct (%) | 60.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1664961825 |
| Minimum | 0.021987 |
|---|---|
| Maximum | 708.703847 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0.021987 |
|---|---|
| 5-th percentile | 0.030867 |
| Q1 | 0.055475 |
| median | 0.124927 |
| Q3 | 0.2062105 |
| 95-th percentile | 0.4196436 |
| Maximum | 708.703847 |
| Range | 708.68186 |
| Interquartile range (IQR) | 0.1507355 |
Descriptive statistics
| Standard deviation | 1.454609655 |
|---|---|
| Coefficient of variation (CV) | 8.736594633 |
| Kurtosis | 199808.3339 |
| Mean | 0.1664961825 |
| Median Absolute Deviation (MAD) | 0.073422 |
| Skewness | 422.3944341 |
| Sum | 47419.27826 |
| Variance | 2.115889248 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.037837 | 13 | < 0.1% |
| 0.033108 | 13 | < 0.1% |
| 0.03242 | 12 | < 0.1% |
| 0.029518 | 12 | < 0.1% |
| 0.035388 | 11 | < 0.1% |
| 0.038326 | 11 | < 0.1% |
| 0.030374 | 11 | < 0.1% |
| 0.033157 | 11 | < 0.1% |
| 0.033043 | 11 | < 0.1% |
| 0.038172 | 11 | < 0.1% |
| Other values (171582) | 284691 |
| Value | Count | Frequency (%) |
| 0.021987 | 1 | |
| 0.022127 | 1 | |
| 0.022439 | 1 | |
| 0.022488 | 1 | |
| 0.022552 | 1 | |
| 0.022594 | 1 | |
| 0.022599 | 1 | |
| 0.022654 | 1 | |
| 0.022695 | 1 | |
| 0.022697 | 1 |
| Value | Count | Frequency (%) |
| 708.703847 | 1 | |
| 220.567456 | 1 | |
| 121.828836 | 1 | |
| 90.426192 | 1 | |
| 83.855285 | 1 | |
| 77.903199 | 1 | |
| 43.265003 | 1 | |
| 37.209066 | 1 | |
| 36.091322 | 1 | |
| 32.901323 | 1 |
| Distinct | 143132 |
|---|---|
| Distinct (%) | 50.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1194891949 |
| Minimum | 0.034156 |
|---|---|
| Maximum | 39.832404 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0.034156 |
|---|---|
| 5-th percentile | 0.046127 |
| Q1 | 0.063903 |
| median | 0.10137 |
| Q3 | 0.1493905 |
| 95-th percentile | 0.2580872 |
| Maximum | 39.832404 |
| Range | 39.798248 |
| Interquartile range (IQR) | 0.0854875 |
Descriptive statistics
| Standard deviation | 0.1375152589 |
|---|---|
| Coefficient of variation (CV) | 1.150859365 |
| Kurtosis | 28090.18909 |
| Mean | 0.1194891949 |
| Median Absolute Deviation (MAD) | 0.040607 |
| Skewness | 118.8801239 |
| Sum | 34031.35913 |
| Variance | 0.01891044644 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.051044 | 13 | < 0.1% |
| 0.060908 | 12 | < 0.1% |
| 0.05279 | 12 | < 0.1% |
| 0.044166 | 12 | < 0.1% |
| 0.055276 | 12 | < 0.1% |
| 0.056232 | 12 | < 0.1% |
| 0.050936 | 11 | < 0.1% |
| 0.053529 | 11 | < 0.1% |
| 0.056868 | 11 | < 0.1% |
| 0.050614 | 11 | < 0.1% |
| Other values (143122) | 284690 |
| Value | Count | Frequency (%) |
| 0.034156 | 1 | |
| 0.034476 | 1 | |
| 0.034644 | 1 | |
| 0.034697 | 1 | |
| 0.034901 | 1 | |
| 0.035019 | 1 | |
| 0.035119 | 1 | |
| 0.035207 | 1 | |
| 0.035265 | 1 | |
| 0.035289 | 1 |
| Value | Count | Frequency (%) |
| 39.832404 | 1 | |
| 22.327885 | 1 | |
| 12.858185 | 1 | |
| 12.272254 | 1 | |
| 12.186537 | 1 | |
| 10.61393 | 1 | |
| 9.502449 | 1 | |
| 8.952156 | 1 | |
| 8.897392 | 1 | |
| 8.373005 | 1 |
| Distinct | 136364 |
|---|---|
| Distinct (%) | 47.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1321145217 |
| Minimum | 0.033318 |
|---|---|
| Maximum | 66.143307 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0.033318 |
|---|---|
| 5-th percentile | 0.0578893 |
| Q1 | 0.0761455 |
| median | 0.101908 |
| Q3 | 0.143657 |
| 95-th percentile | 0.2997737 |
| Maximum | 66.143307 |
| Range | 66.109989 |
| Interquartile range (IQR) | 0.0675115 |
Descriptive statistics
| Standard deviation | 0.2091837423 |
|---|---|
| Coefficient of variation (CV) | 1.583351623 |
| Kurtosis | 38116.37042 |
| Mean | 0.1321145217 |
| Median Absolute Deviation (MAD) | 0.030354 |
| Skewness | 142.2519051 |
| Sum | 37627.14057 |
| Variance | 0.04375783806 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.076775 | 13 | < 0.1% |
| 0.068524 | 13 | < 0.1% |
| 0.075621 | 12 | < 0.1% |
| 0.076402 | 12 | < 0.1% |
| 0.070139 | 12 | < 0.1% |
| 0.141784 | 12 | < 0.1% |
| 0.075189 | 11 | < 0.1% |
| 0.090621 | 11 | < 0.1% |
| 0.083715 | 11 | < 0.1% |
| 0.06724 | 11 | < 0.1% |
| Other values (136354) | 284689 |
| Value | Count | Frequency (%) |
| 0.033318 | 2 | |
| 0.039556 | 1 | |
| 0.039569 | 1 | |
| 0.04054 | 1 | |
| 0.041432 | 1 | |
| 0.041443 | 1 | |
| 0.041504 | 1 | |
| 0.041734 | 1 | |
| 0.041752 | 1 | |
| 0.042023 | 1 |
| Value | Count | Frequency (%) |
| 66.143307 | 1 | |
| 32.41625 | 1 | |
| 20.440717 | 1 | |
| 20.024466 | 1 | |
| 18.334789 | 1 | |
| 17.491723 | 1 | |
| 13.247561 | 1 | |
| 11.959482 | 1 | |
| 11.846359 | 1 | |
| 11.37197 | 1 |
| Distinct | 171161 |
|---|---|
| Distinct (%) | 60.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2198274226 |
| Minimum | 0.044069 |
|---|---|
| Maximum | 47.529248 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.2 MiB |
Quantile statistics
| Minimum | 0.044069 |
|---|---|
| 5-th percentile | 0.0796933 |
| Q1 | 0.110915 |
| median | 0.151384 |
| Q3 | 0.229893 |
| 95-th percentile | 0.628709 |
| Maximum | 47.529248 |
| Range | 47.485179 |
| Interquartile range (IQR) | 0.118978 |
Descriptive statistics
| Standard deviation | 0.2839616411 |
|---|---|
| Coefficient of variation (CV) | 1.291748035 |
| Kurtosis | 4520.541349 |
| Mean | 0.2198274226 |
| Median Absolute Deviation (MAD) | 0.049726 |
| Skewness | 41.65436631 |
| Sum | 62608.38874 |
| Variance | 0.08063421359 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.146039 | 10 | < 0.1% |
| 0.143381 | 10 | < 0.1% |
| 0.128688 | 10 | < 0.1% |
| 0.123547 | 10 | < 0.1% |
| 0.10685 | 9 | < 0.1% |
| 0.108653 | 9 | < 0.1% |
| 0.105764 | 9 | < 0.1% |
| 0.116664 | 9 | < 0.1% |
| 0.115216 | 9 | < 0.1% |
| 0.106753 | 9 | < 0.1% |
| Other values (171151) | 284713 |
| Value | Count | Frequency (%) |
| 0.044069 | 1 | |
| 0.044153 | 2 | |
| 0.044297 | 1 | |
| 0.044667 | 1 | |
| 0.045021 | 1 | |
| 0.045421 | 1 | |
| 0.046718 | 1 | |
| 0.047086 | 1 | |
| 0.04752 | 1 | |
| 0.047619 | 1 |
| Value | Count | Frequency (%) |
| 47.529248 | 1 | |
| 29.875302 | 1 | |
| 28.713682 | 1 | |
| 26.365085 | 1 | |
| 23.711179 | 1 | |
| 22.242674 | 1 | |
| 19.015472 | 1 | |
| 17.928994 | 1 | |
| 17.246654 | 1 | |
| 16.943693 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| ID | u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1237645879562928805 | 25.155375 | 22.232981 | 21.257841 | 19.889854 | 19.427107 | 1.034657 | 0.219033 | 0.206952 | 0.147347 | 0.228686 |
| 1 | 1237645942905504040 | 21.910667 | 19.464439 | 18.372978 | 17.955502 | 17.642979 | 0.443852 | 0.060666 | 0.064809 | 0.069981 | 0.096798 |
| 2 | 1237645942905635180 | 20.978670 | 20.276821 | 19.472305 | 19.232706 | 18.994177 | 0.150120 | 0.070810 | 0.076891 | 0.085570 | 0.132459 |
| 3 | 1237645942906224860 | 20.389980 | 19.313643 | 17.891615 | 17.415066 | 17.181231 | 0.331636 | 0.113295 | 0.092397 | 0.093178 | 0.127449 |
| 4 | 1237645943978721520 | 23.907169 | 23.448675 | 20.256517 | 19.163860 | 18.557152 | 1.527960 | 1.033415 | 0.177488 | 0.132869 | 0.149485 |
| 5 | 1237645943978787138 | 20.503014 | 19.280542 | 18.830477 | 18.559280 | 18.481827 | 0.120214 | 0.044740 | 0.061519 | 0.071990 | 0.098771 |
| 6 | 1237645943978787212 | 21.728035 | 19.977358 | 18.901865 | 18.379099 | 18.037195 | 0.315895 | 0.061951 | 0.063594 | 0.068638 | 0.084922 |
| 7 | 1237645943978787238 | 20.095301 | 18.808825 | 18.192244 | 17.883970 | 17.655457 | 0.139342 | 0.054625 | 0.073051 | 0.085504 | 0.116468 |
| 8 | 1237645943978852526 | 19.983652 | 18.805828 | 17.918039 | 17.496410 | 17.238651 | 0.092822 | 0.042239 | 0.054085 | 0.062537 | 0.077156 |
| 9 | 1237645943978852865 | 24.602087 | 21.488087 | 19.520910 | 18.921425 | 18.594252 | 0.866716 | 0.179641 | 0.090975 | 0.091485 | 0.116313 |
Last rows
| ID | u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 284797 | 1237679440425582965 | 23.639347 | 22.198999 | 21.031853 | 20.623516 | 20.220276 | 1.164313 | 0.207720 | 0.168991 | 0.189767 | 0.281953 |
| 284798 | 1237679440425582993 | 25.019598 | 23.568682 | 21.386972 | 20.716246 | 20.140373 | 1.166885 | 0.510955 | 0.181036 | 0.170606 | 0.219201 |
| 284799 | 1237679440425582999 | 23.800091 | 22.663116 | 21.376005 | 21.033384 | 20.509428 | 0.758078 | 0.172692 | 0.121977 | 0.141194 | 0.193995 |
| 284800 | 1237679440425583065 | 24.128036 | 22.615719 | 22.088884 | 22.170218 | 22.780581 | 0.840129 | 0.162339 | 0.193105 | 0.295670 | 0.616266 |
| 284801 | 1237679440425583321 | 24.797550 | 24.092091 | 22.128248 | 21.591732 | 21.169786 | 0.827333 | 0.469421 | 0.201903 | 0.198841 | 0.295564 |
| 284802 | 1237679440425583329 | 24.976448 | 24.600201 | 22.031639 | 21.277906 | 21.742359 | 0.993866 | 0.745757 | 0.237257 | 0.203570 | 0.556340 |
| 284803 | 1237679440425583352 | 22.115126 | 22.939453 | 21.892546 | 21.643509 | 21.161491 | 0.297924 | 0.287982 | 0.238297 | 0.287231 | 0.418816 |
| 284804 | 1237679440425583393 | 25.053223 | 23.429272 | 21.970121 | 21.796354 | 21.764332 | 0.960138 | 0.374865 | 0.223337 | 0.289326 | 0.562293 |
| 284805 | 1237679440425583406 | 23.518948 | 23.862247 | 22.476570 | 23.323412 | 22.473553 | 0.665053 | 0.426565 | 0.271013 | 0.674657 | 0.628833 |
| 284806 | 1237679440425583552 | 23.850555 | 23.662268 | 22.625984 | 21.673103 | 20.727907 | 0.995684 | 0.475650 | 0.380495 | 0.279438 | 0.296898 |
Most frequently occurring
| ID | u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10069 | 1237663782593822805 | 22.283274 | 21.068048 | 20.495552 | 20.152773 | 20.320446 | 0.280162 | 0.097535 | 0.112381 | 0.128407 | 0.269480 | 3 |
| 0 | 1237645942905045292 | 21.549091 | 20.449072 | 19.491505 | 19.109482 | 19.031570 | 0.187775 | 0.064391 | 0.070761 | 0.078279 | 0.133099 | 2 |
| 1 | 1237645942905766350 | 22.381472 | 19.829432 | 19.195267 | 18.889847 | 18.783106 | 0.565267 | 0.065301 | 0.079979 | 0.087633 | 0.143001 | 2 |
| 2 | 1237645942906028543 | 21.952278 | 19.570076 | 19.224197 | 19.068018 | 19.586912 | 0.779489 | 0.104354 | 0.127184 | 0.139830 | 0.296508 | 2 |
| 3 | 1237645942906290775 | 21.619223 | 21.169184 | 19.880489 | 19.315659 | 19.067236 | 0.579738 | 0.248283 | 0.162171 | 0.133410 | 0.193769 | 2 |
| 4 | 1237645943433527759 | 22.585049 | 22.089539 | 20.596846 | 20.023451 | 19.693275 | 0.251315 | 0.131726 | 0.085136 | 0.090215 | 0.125546 | 2 |
| 5 | 1237645943433528154 | 25.503576 | 23.376709 | 21.655865 | 21.130768 | 20.611811 | 0.415402 | 0.337225 | 0.155960 | 0.161406 | 0.229532 | 2 |
| 6 | 1237645943976493336 | 21.058979 | 20.268528 | 19.704321 | 19.551207 | 19.345476 | 0.139671 | 0.059261 | 0.075314 | 0.093654 | 0.133140 | 2 |
| 7 | 1237645943978590448 | 23.604773 | 20.865627 | 19.520216 | 18.991688 | 18.603312 | 0.855619 | 0.086042 | 0.071080 | 0.075468 | 0.092440 | 2 |
| 8 | 1237645943978852851 | 23.211906 | 21.698839 | 20.068785 | 19.535690 | 19.161798 | 0.842152 | 0.182576 | 0.104862 | 0.105967 | 0.141706 | 2 |